namespace WebApplication1
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    [Table("ProductDB")]
    public partial class ProductDB
    {
        public ProductDB()
        {
            Bacchus = new HashSet<Bacchu>();
            Conditions = new HashSet<Condition>();
            Hot6 = new HashSet<Hot6>();
            LotNumbers = new HashSet<LotNumber>();
            Materials = new HashSet<Material>();
            Product_Mid = new HashSet<Product_Mid>();
            ProductOuts = new HashSet<ProductOut>();
            Vita500 = new HashSet<Vita500>();
        }

        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.None)]
        public int Pro_Id { get; set; }

        [Required]
        [StringLength(26)]
        public string Pro_Name { get; set; }

        [StringLength(20)]
        public string Pro_Group { get; set; }

        public int? Pro_Quantity { get; set; }

        [StringLength(10)]
        public string Pro_Unit { get; set; }

        public int? Pro_InPrice { get; set; }

        public int? Pro_OutPrice { get; set; }

        public int? Pro_Inventory { get; set; }

        [StringLength(1000)]
        public string Pro_Memo { get; set; }

        [StringLength(500)]
        public string Pro_Image { get; set; }

        [StringLength(10)]
        public string Mem_Name { get; set; }

        [StringLength(20)]
        public string PM_LotNumber { get; set; }

        public virtual ICollection<Bacchu> Bacchus { get; set; }

        public virtual ICollection<Condition> Conditions { get; set; }

        public virtual ICollection<Hot6> Hot6 { get; set; }

        public virtual ICollection<LotNumber> LotNumbers { get; set; }

        public virtual ICollection<Material> Materials { get; set; }

        public virtual ICollection<Product_Mid> Product_Mid { get; set; }

        public virtual ICollection<ProductOut> ProductOuts { get; set; }

        public virtual ICollection<Vita500> Vita500 { get; set; }
    }
}
